package com.kvest.sqlitetest.datastorage.sqlitestorage.table;

import android.provider.BaseColumns;

/**
 * Created with IntelliJ IDEA.
 * User: Kvest
 * Date: 15.06.13
 * Time: 17:48
 * To change this template use File | Settings | File Templates.
 */
public abstract class FirmPersonTable implements BaseColumns {
    public static final String TABLE_NAME = "firm_person";

    public static final String FIRM_ID_COLUMN = "firm_id";
    public static final String PERSON_ID_COLUMN = "person_id";

    public static final String CREATE_TABLE_SQL = "CREATE TABLE \'" + TABLE_NAME + "'(\'" +
            _ID + "\' INTEGER PRIMARY KEY AUTOINCREMENT, \'" +
            FIRM_ID_COLUMN + "\' INTEGER NOT NULL, \'" +
            PERSON_ID_COLUMN + "\' INTEGER NOT NULL);";
    public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS \'" + TABLE_NAME + "\';";
}
